package com.wyp.mapper;

import com.wyp.pojo.Scores;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface ScoresMapper {

    public int GetScoresCount();

    //返回所有成绩信息给前端页面
    public List<Map<String,Object>> qureyAllScores();

    //查询考生信息
    public Scores qureyScoresByRepeat(@Param("stuid") int stuid, @Param("testpaperid") int testpaperid);
    public List<Map<String,Object>> qureyScoresByStuid(int stuid);
    public List<Map<String,Object>> qureyScoresByReach(int stuid);
    public List<Map<String,Object>> qureyScoresByStuTest(@Param("stuid") int stuid, @Param("testpapername") String testpapername);
    public Map<String,Object> qureyScoresByScoresid(int scoid);
    public List<Map<String,Object>> qureyScoresByStuname(String stuname);
    public List<Map<String,Object>> qureyScoresByPapername(String testpapername);



    //更新成绩信息
    public int updateScores(Scores scores);

    //添加成绩信息
    public int addScores(Scores scores);

    //删除成绩信息
    public int deleteScores(Integer id);
}
